CREATE TABLE [dbo].[JY_Action]
(
[JY_Action_ID] [int] NOT NULL IDENTITY(1, 1),
[JY_Action_Title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Action_Person] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Action_Time] [datetime] NULL,
[JY_Action_Address] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Action_ZB_Unit] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Action_CB_Unit] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Action_Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JY_Action_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JY_Action_Add_User] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Action_Add_Time] [datetime] NULL,
[JY_Action_Status] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Action_Top_Status] [int] NULL,
[JY_Action_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Action_Click_Number] [int] NULL,
[JY_Action_Download] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JY_Action] ADD CONSTRAINT [PK_JY_JZ] PRIMARY KEY CLUSTERED  ([JY_Action_ID]) ON [PRIMARY]
GO
